<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>List of Student</title>
    <link rel="stylesheet" href="css/style.css" type="text/css">
    <link href="css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Student Registration</title>
    <link href="css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<br>

<div class="container">
    <div class="panel panel-default">
        <div class="panel-heading">
            <div class="row">
                <div class="col-lg-6">
                    <h2>List of Student</h2>
                </div>
            </div>
        </div>
        <div class="panel-body">
            <div class="row">
                <div class="col-sm-3">
                    <a role="button" href="index.html" class="btn btn-info">Back to Main Page</a>
                </div>
            </div>
            <br>
            <?php
            include_once 'connect_DB.php';
            $query = mysqli_query($con, "SELECT * FROM user_db ORDER BY ID ASC");
            while ($row = mysqli_fetch_array($query)) {
                printf('  <div class="row">
                <div class="col-sm-1">
                %u
                </div>
                <div class="col-sm-3">
                    <a href="profile.php?ID=%u">%s %s </a>
                </div>
            </div>', $row['ID'],$row['ID'], $row['FIRST_NAME'], $row['SURNAME']);
            }
            ?>
        </div>
    </div>
</div>
</body>
<script src="js/jquery-1.10.2.js"></script>
<script src="js/bootstrap.js"></script>
</html>

